Introduction

With the ever changing business environment, it is becoming increasingly difficult to keep track of the development in the different business areas. Every functional head has his/her own feel and perception of the market based on his/her own experience and encounter on ground. It is so critical for functional heads to keep abreast of the latest business development so that they can confidently steer the company towards a specific goal with an optimal amount of resources. Budgeting is an excellent way of finding out the optimism of the market as the business function heads put down their estimates for the new year. Although the number may not materialize as the business environment changes, the budgeted numbers serve as a valuable benchmark for the company to navigate itself through good times and bad times. 

Course Objectives

1. To equip participants who are new to budgeting with an efficient and accurate approach to budgeting using Excel.
2. Using just formulas and readily available functions in Excel, participants will learn how they could manage their budget confidently and consolidate the budget submission.
3. Through this approach, participants will be able to increase the frequency of budgeting / forecasting from annual basis to monthly basis with minimal increase in resources.
4. Participants will learn how to avoid the pitfalls of linking multiple files and worry about broken links between workbooks. Cutting and pasting of rows of records are also kept to a minimum.  

Course Outline

1. How to align the headers and sub-headers with the data input using existing formulas in Excel.
2. Transform the data input into a Data Cluster
3. Analyze the business units numbers using the data cluster and pivot table, a powerful analytic tool in Excel
4. Combine the Data Clusters into a Data Hub so that company’s budget can be presented in minutes without spending more money on new programs and hardware
5. Analyze the budget at all levels. Participants will learn how to use the report to drill down to the most level easily.
6. Prepare Dashboard, summary reports and charts using the Data Hub, the only single source of data for all.  

Trainer(s)

Who Should Attend

CFO, Financial Controller, Finance Managers, Business Managers and Finance Executives who are looking for effective budgeting solutions provided by budgeting software without the need to spend tens of thousands of dollars to implement. Participants must be familiar with the Microsoft Excel and possess advanced Excel skills. They must know advanced worksheet formulas in Excel and how to create a pivot table, preferably attended business analysis with Excel course.  

Course Details

Date:

5 to 6 October 2009 

Time:

9:00am to 5:00pm 

Venue:

NTU@one-north campus, Executive Centre 

Closing Date:

21 September 2009 

Fee:

Standard: SGD$1000   Alumni: SGD$800   Group (3 & Above): SGD$900

Registration fees inclusive of:

• Course materials

• Light refreshments

• Lunch

• Complimentary parking (1 entry/day) - applicable at NTU@one-north campus only.

• Prevailing GST

Online Registration

>> CLICK HERE to Register Online

Methods of Payment

1. Credit Card (Visa and Mastercard only)

2. Cheque made payable to Nanyang Technological University

3. Invoice to Company (for Company Sponsored Participants)

4. E-invoice (for Government Organizations)

Cancellation & Refund Policy

Engineering | Accounts/Business/HRM | IT & Information Studies | Personal Development | Communications | Education

© 2009 Nanyang Technological University. All rights reserved. Copyright, Disclaimer, Privacy Statement.